package com.mybatis_multitable.mapper;

import com.mybatis_multitable.pojo.Role;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface RoleMapper {
    
    @Select("SELECT * from sys_user_role ur,sys_role r WHERE ur.roleid = r.id and ur.userid = #{uid}")
    List<Role> findRoleByUid(Integer uid);
}
